package com.neusoft.EYSystem.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.neusoft.EYSystem.po.Client;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface ClientDAO extends BaseMapper<Client> {
    // 这里可以扩展自定义SQL，比如模糊查询、联表等

    @Select("SELECT * FROM client WHERE status = 'active' AND (phone = #{username} OR name = #{username} OR id_number = #{username})")
    List<Client> getClient(String username);
}
